﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="rodeioDataSet" targetNamespace="http://tempuri.org/rodeioDataSet.xsd" xmlns:mstns="http://tempuri.org/rodeioDataSet.xsd" xmlns="http://tempuri.org/rodeioDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="rodeioConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="rodeioConnectionString (Settings)" PropertyReference="ApplicationSettings.main_fx.Properties.Settings.GlobalReference.Default.rodeioConnectionString" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ANIMALTableAdapter" GeneratorDataComponentClassName="ANIMALTableAdapter" Name="ANIMAL" UserDataComponentName="ANIMALTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="rodeioConnectionString (Settings)" DbObjectName="ANIMAL" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `ANIMAL` WHERE ((`ID_ANIMAL` = ?) AND ((? = 1 AND `NOME` IS NULL) OR (`NOME` = ?)) AND ((? = 1 AND `COMPANHIA` IS NULL) OR (`COMPANHIA` = ?)) AND ((? = 1 AND `GRUPO` IS NULL) OR (`GRUPO` = ?)) AND ((? = 1 AND `ESPECIE` IS NULL) OR (`ESPECIE` = ?)) AND ((? = 1 AND `FOTO` IS NULL) OR (`FOTO` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID_ANIMAL" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_ANIMAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOME" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NOME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COMPANHIA" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="COMPANHIA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_COMPANHIA" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="COMPANHIA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GRUPO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GRUPO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GRUPO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GRUPO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESPECIE" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ESPECIE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ESPECIE" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ESPECIE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FOTO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FOTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_FOTO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FOTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `ANIMAL` (`NOME`, `COMPANHIA`, `GRUPO`, `ESPECIE`, `FOTO`) VALUES (?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NOME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="COMPANHIA" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="COMPANHIA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GRUPO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GRUPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ESPECIE" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ESPECIE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="FOTO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FOTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_ANIMAL, NOME, COMPANHIA, GRUPO, ESPECIE, FOTO FROM ANIMAL</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `ANIMAL` SET `NOME` = ?, `COMPANHIA` = ?, `GRUPO` = ?, `ESPECIE` = ?, `FOTO` = ? WHERE ((`ID_ANIMAL` = ?) AND ((? = 1 AND `NOME` IS NULL) OR (`NOME` = ?)) AND ((? = 1 AND `COMPANHIA` IS NULL) OR (`COMPANHIA` = ?)) AND ((? = 1 AND `GRUPO` IS NULL) OR (`GRUPO` = ?)) AND ((? = 1 AND `ESPECIE` IS NULL) OR (`ESPECIE` = ?)) AND ((? = 1 AND `FOTO` IS NULL) OR (`FOTO` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NOME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="COMPANHIA" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="COMPANHIA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GRUPO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GRUPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ESPECIE" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ESPECIE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="FOTO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FOTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID_ANIMAL" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_ANIMAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOME" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NOME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_COMPANHIA" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="COMPANHIA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_COMPANHIA" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="COMPANHIA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GRUPO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GRUPO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GRUPO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GRUPO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ESPECIE" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ESPECIE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ESPECIE" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ESPECIE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FOTO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FOTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_FOTO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FOTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_ANIMAL" DataSetColumn="ID_ANIMAL" />
              <Mapping SourceColumn="NOME" DataSetColumn="NOME" />
              <Mapping SourceColumn="COMPANHIA" DataSetColumn="COMPANHIA" />
              <Mapping SourceColumn="GRUPO" DataSetColumn="GRUPO" />
              <Mapping SourceColumn="ESPECIE" DataSetColumn="ESPECIE" />
              <Mapping SourceColumn="FOTO" DataSetColumn="FOTO" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="COMPETICAOTableAdapter" GeneratorDataComponentClassName="COMPETICAOTableAdapter" Name="COMPETICAO" UserDataComponentName="COMPETICAOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="rodeioConnectionString (Settings)" DbObjectName="COMPETICAO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `COMPETICAO` WHERE ((`ID_COMPETICAO` = ?) AND ((? = 1 AND `NOME` IS NULL) OR (`NOME` = ?)) AND ((? = 1 AND `DATA` IS NULL) OR (`DATA` = ?)) AND ((? = 1 AND `IDPEAO` IS NULL) OR (`IDPEAO` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID_COMPETICAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_COMPETICAO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOME" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NOME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DATA" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DATA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_DATA" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DATA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPEAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDPEAO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IDPEAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDPEAO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `COMPETICAO` (`NOME`, `DATA`, `IDPEAO`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NOME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="DATA" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DATA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IDPEAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDPEAO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_COMPETICAO, NOME, DATA, IDPEAO FROM COMPETICAO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `COMPETICAO` SET `NOME` = ?, `DATA` = ?, `IDPEAO` = ? WHERE ((`ID_COMPETICAO` = ?) AND ((? = 1 AND `NOME` IS NULL) OR (`NOME` = ?)) AND ((? = 1 AND `DATA` IS NULL) OR (`DATA` = ?)) AND ((? = 1 AND `IDPEAO` IS NULL) OR (`IDPEAO` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NOME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="DATA" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DATA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IDPEAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDPEAO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID_COMPETICAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_COMPETICAO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOME" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NOME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DATA" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DATA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_DATA" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DATA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IDPEAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDPEAO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IDPEAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IDPEAO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_COMPETICAO" DataSetColumn="ID_COMPETICAO" />
              <Mapping SourceColumn="NOME" DataSetColumn="NOME" />
              <Mapping SourceColumn="DATA" DataSetColumn="DATA" />
              <Mapping SourceColumn="IDPEAO" DataSetColumn="IDPEAO" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="JUIZTableAdapter" GeneratorDataComponentClassName="JUIZTableAdapter" Name="JUIZ" UserDataComponentName="JUIZTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="rodeioConnectionString (Settings)" DbObjectName="JUIZ" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `JUIZ` WHERE ((`ID_JUIZ` = ?) AND ((? = 1 AND `NOME` IS NULL) OR (`NOME` = ?)) AND ((? = 1 AND `APELIDO` IS NULL) OR (`APELIDO` = ?)) AND ((? = 1 AND `CIDADE` IS NULL) OR (`CIDADE` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID_JUIZ" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_JUIZ" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOME" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NOME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_APELIDO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="APELIDO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_APELIDO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="APELIDO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CIDADE" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CIDADE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CIDADE" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CIDADE" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `JUIZ` (`NOME`, `APELIDO`, `CIDADE`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NOME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="APELIDO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="APELIDO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CIDADE" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CIDADE" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_JUIZ, NOME, APELIDO, CIDADE FROM JUIZ</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `JUIZ` SET `NOME` = ?, `APELIDO` = ?, `CIDADE` = ? WHERE ((`ID_JUIZ` = ?) AND ((? = 1 AND `NOME` IS NULL) OR (`NOME` = ?)) AND ((? = 1 AND `APELIDO` IS NULL) OR (`APELIDO` = ?)) AND ((? = 1 AND `CIDADE` IS NULL) OR (`CIDADE` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NOME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="APELIDO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="APELIDO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CIDADE" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CIDADE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID_JUIZ" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_JUIZ" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOME" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NOME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_APELIDO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="APELIDO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_APELIDO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="APELIDO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CIDADE" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CIDADE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CIDADE" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CIDADE" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_JUIZ" DataSetColumn="ID_JUIZ" />
              <Mapping SourceColumn="NOME" DataSetColumn="NOME" />
              <Mapping SourceColumn="APELIDO" DataSetColumn="APELIDO" />
              <Mapping SourceColumn="CIDADE" DataSetColumn="CIDADE" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PEAOTableAdapter" GeneratorDataComponentClassName="PEAOTableAdapter" Name="PEAO" UserDataComponentName="PEAOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="rodeioConnectionString (Settings)" DbObjectName="PEAO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `PEAO` WHERE ((`ID_PEAO` = ?) AND ((? = 1 AND `NOME` IS NULL) OR (`NOME` = ?)) AND ((? = 1 AND `CIDADE` IS NULL) OR (`CIDADE` = ?)) AND ((? = 1 AND `GRUPO` IS NULL) OR (`GRUPO` = ?)) AND ((? = 1 AND `CATEGORIA` IS NULL) OR (`CATEGORIA` = ?)) AND ((? = 1 AND `APELIDO` IS NULL) OR (`APELIDO` = ?)) AND ((? = 1 AND `FOTO` IS NULL) OR (`FOTO` = ?)) AND ((? = 1 AND `ATIVO` IS NULL) OR (`ATIVO` = ?)) AND ((? = 1 AND `id_comp` IS NULL) OR (`id_comp` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID_PEAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_PEAO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOME" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NOME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CIDADE" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CIDADE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CIDADE" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CIDADE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GRUPO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GRUPO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GRUPO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GRUPO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CATEGORIA" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CATEGORIA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CATEGORIA" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CATEGORIA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_APELIDO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="APELIDO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_APELIDO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="APELIDO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FOTO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FOTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_FOTO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FOTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ATIVO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ATIVO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_ATIVO" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="ATIVO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_id_comp" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="id_comp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_id_comp" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="id_comp" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `PEAO` (`NOME`, `CIDADE`, `GRUPO`, `CATEGORIA`, `APELIDO`, `FOTO`, `ATIVO`, `id_comp`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NOME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CIDADE" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CIDADE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GRUPO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GRUPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CATEGORIA" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CATEGORIA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="APELIDO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="APELIDO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="FOTO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FOTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="ATIVO" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="ATIVO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="id_comp" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="id_comp" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_PEAO, NOME, CIDADE, GRUPO, CATEGORIA, APELIDO, FOTO, ATIVO, id_comp FROM PEAO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `PEAO` SET `NOME` = ?, `CIDADE` = ?, `GRUPO` = ?, `CATEGORIA` = ?, `APELIDO` = ?, `FOTO` = ?, `ATIVO` = ?, `id_comp` = ? WHERE ((`ID_PEAO` = ?) AND ((? = 1 AND `NOME` IS NULL) OR (`NOME` = ?)) AND ((? = 1 AND `CIDADE` IS NULL) OR (`CIDADE` = ?)) AND ((? = 1 AND `GRUPO` IS NULL) OR (`GRUPO` = ?)) AND ((? = 1 AND `CATEGORIA` IS NULL) OR (`CATEGORIA` = ?)) AND ((? = 1 AND `APELIDO` IS NULL) OR (`APELIDO` = ?)) AND ((? = 1 AND `FOTO` IS NULL) OR (`FOTO` = ?)) AND ((? = 1 AND `ATIVO` IS NULL) OR (`ATIVO` = ?)) AND ((? = 1 AND `id_comp` IS NULL) OR (`id_comp` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="NOME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CIDADE" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CIDADE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GRUPO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GRUPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CATEGORIA" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CATEGORIA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="APELIDO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="APELIDO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="FOTO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FOTO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="ATIVO" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="ATIVO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="id_comp" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="id_comp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID_PEAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_PEAO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOME" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_NOME" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="NOME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CIDADE" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CIDADE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CIDADE" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CIDADE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GRUPO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GRUPO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GRUPO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GRUPO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CATEGORIA" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CATEGORIA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CATEGORIA" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CATEGORIA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_APELIDO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="APELIDO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_APELIDO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="APELIDO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FOTO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FOTO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_FOTO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FOTO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ATIVO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ATIVO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_ATIVO" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="ATIVO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_id_comp" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="id_comp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_id_comp" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="id_comp" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_PEAO" DataSetColumn="ID_PEAO" />
              <Mapping SourceColumn="NOME" DataSetColumn="NOME" />
              <Mapping SourceColumn="CIDADE" DataSetColumn="CIDADE" />
              <Mapping SourceColumn="GRUPO" DataSetColumn="GRUPO" />
              <Mapping SourceColumn="CATEGORIA" DataSetColumn="CATEGORIA" />
              <Mapping SourceColumn="APELIDO" DataSetColumn="APELIDO" />
              <Mapping SourceColumn="FOTO" DataSetColumn="FOTO" />
              <Mapping SourceColumn="ATIVO" DataSetColumn="ATIVO" />
              <Mapping SourceColumn="id_comp" DataSetColumn="id_comp" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="rodeioConnectionString (Settings)" DbObjectName="PEAO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByPeaoAtivo" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByPeaoAtivo" GeneratorSourceName="FillByPeaoAtivo" GetMethodModifier="Public" GetMethodName="GetDataByPeaoAtivo" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByPeaoAtivo" UserSourceName="FillByPeaoAtivo">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ID_PEAO, NOME, CIDADE, GRUPO, CATEGORIA, APELIDO, FOTO, ATIVO, id_comp
FROM            PEAO
WHERE        (ATIVO = true) AND (id_comp = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="id_comp" DataSourceName="PEAO" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="id_comp" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="id_comp" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RANKINGTableAdapter" GeneratorDataComponentClassName="RANKINGTableAdapter" Name="RANKING" UserDataComponentName="RANKINGTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="rodeioConnectionString (Settings)" DbObjectName="RANKING" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `RANKING` WHERE ((`ID_RANK` = ?) AND ((? = 1 AND `ID_PEAO` IS NULL) OR (`ID_PEAO` = ?)) AND ((? = 1 AND `ID_ANIMAL` IS NULL) OR (`ID_ANIMAL` = ?)) AND ((? = 1 AND `ID_COMP` IS NULL) OR (`ID_COMP` = ?)) AND ((? = 1 AND `NOTA1` IS NULL) OR (`NOTA1` = ?)) AND ((? = 1 AND `NOTA2` IS NULL) OR (`NOTA2` = ?)) AND ((? = 1 AND `MEDIA` IS NULL) OR (`MEDIA` = ?)) AND ((? = 1 AND `TEMPO` IS NULL) OR (`TEMPO` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID_RANK" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_RANK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ID_PEAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_PEAO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID_PEAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_PEAO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ID_ANIMAL" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_ANIMAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID_ANIMAL" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_ANIMAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ID_COMP" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_COMP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID_COMP" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_COMP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOTA1" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NOTA1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_NOTA1" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NOTA1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOTA2" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NOTA2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_NOTA2" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NOTA2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_MEDIA" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="MEDIA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_MEDIA" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="MEDIA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TEMPO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TEMPO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_TEMPO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TEMPO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `RANKING` (`ID_PEAO`, `ID_ANIMAL`, `ID_COMP`, `NOTA1`, `NOTA2`, `MEDIA`, `TEMPO`) VALUES (?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID_PEAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_PEAO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID_ANIMAL" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_ANIMAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID_COMP" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_COMP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="NOTA1" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NOTA1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="NOTA2" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NOTA2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="MEDIA" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="MEDIA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TEMPO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TEMPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_RANK, ID_PEAO, ID_ANIMAL, ID_COMP, NOTA1, NOTA2, MEDIA, TEMPO FROM RANKING</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `RANKING` SET `ID_PEAO` = ?, `ID_ANIMAL` = ?, `ID_COMP` = ?, `NOTA1` = ?, `NOTA2` = ?, `MEDIA` = ?, `TEMPO` = ? WHERE ((`ID_RANK` = ?) AND ((? = 1 AND `ID_PEAO` IS NULL) OR (`ID_PEAO` = ?)) AND ((? = 1 AND `ID_ANIMAL` IS NULL) OR (`ID_ANIMAL` = ?)) AND ((? = 1 AND `ID_COMP` IS NULL) OR (`ID_COMP` = ?)) AND ((? = 1 AND `NOTA1` IS NULL) OR (`NOTA1` = ?)) AND ((? = 1 AND `NOTA2` IS NULL) OR (`NOTA2` = ?)) AND ((? = 1 AND `MEDIA` IS NULL) OR (`MEDIA` = ?)) AND ((? = 1 AND `TEMPO` IS NULL) OR (`TEMPO` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID_PEAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_PEAO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID_ANIMAL" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_ANIMAL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID_COMP" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_COMP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="NOTA1" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NOTA1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="NOTA2" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NOTA2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="MEDIA" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="MEDIA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TEMPO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TEMPO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID_RANK" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_RANK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ID_PEAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_PEAO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID_PEAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_PEAO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ID_ANIMAL" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_ANIMAL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID_ANIMAL" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_ANIMAL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ID_COMP" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_COMP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID_COMP" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_COMP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOTA1" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NOTA1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_NOTA1" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NOTA1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NOTA2" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NOTA2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_NOTA2" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NOTA2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_MEDIA" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="MEDIA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_MEDIA" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="MEDIA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TEMPO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TEMPO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_TEMPO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TEMPO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_RANK" DataSetColumn="ID_RANK" />
              <Mapping SourceColumn="ID_PEAO" DataSetColumn="ID_PEAO" />
              <Mapping SourceColumn="ID_ANIMAL" DataSetColumn="ID_ANIMAL" />
              <Mapping SourceColumn="ID_COMP" DataSetColumn="ID_COMP" />
              <Mapping SourceColumn="NOTA1" DataSetColumn="NOTA1" />
              <Mapping SourceColumn="NOTA2" DataSetColumn="NOTA2" />
              <Mapping SourceColumn="MEDIA" DataSetColumn="MEDIA" />
              <Mapping SourceColumn="TEMPO" DataSetColumn="TEMPO" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="rodeioConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="ScalarQueryJALIstado" Modifier="Public" Name="ScalarQueryJALIstado" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="ScalarQueryJALIstado">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        COUNT(*) AS Expr1
FROM            RANKING
WHERE        (ID_COMP = ?) AND (ID_PEAO = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="ID_COMP" DataSourceName="RANKING" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ID_COMP" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_COMP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="ID_PEAO" DataSourceName="RANKING" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="ID_PEAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID_PEAO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="rodeioDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="rodeioDataSet" msprop:Generator_UserDSName="rodeioDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="ANIMAL" msprop:Generator_TableClassName="ANIMALDataTable" msprop:Generator_TableVarName="tableANIMAL" msprop:Generator_RowChangedName="ANIMALRowChanged" msprop:Generator_TablePropName="ANIMAL" msprop:Generator_RowDeletingName="ANIMALRowDeleting" msprop:Generator_RowChangingName="ANIMALRowChanging" msprop:Generator_RowEvHandlerName="ANIMALRowChangeEventHandler" msprop:Generator_RowDeletedName="ANIMALRowDeleted" msprop:Generator_RowClassName="ANIMALRow" msprop:Generator_UserTableName="ANIMAL" msprop:Generator_RowEvArgName="ANIMALRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_ANIMAL" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID_ANIMAL" msprop:Generator_ColumnPropNameInRow="ID_ANIMAL" msprop:Generator_ColumnPropNameInTable="ID_ANIMALColumn" msprop:Generator_UserColumnName="ID_ANIMAL" type="xs:int" />
              <xs:element name="NOME" msprop:Generator_ColumnVarNameInTable="columnNOME" msprop:Generator_ColumnPropNameInRow="NOME" msprop:Generator_ColumnPropNameInTable="NOMEColumn" msprop:Generator_UserColumnName="NOME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="COMPANHIA" msprop:Generator_ColumnVarNameInTable="columnCOMPANHIA" msprop:Generator_ColumnPropNameInRow="COMPANHIA" msprop:Generator_ColumnPropNameInTable="COMPANHIAColumn" msprop:Generator_UserColumnName="COMPANHIA" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GRUPO" msprop:Generator_ColumnVarNameInTable="columnGRUPO" msprop:Generator_ColumnPropNameInRow="GRUPO" msprop:Generator_ColumnPropNameInTable="GRUPOColumn" msprop:Generator_UserColumnName="GRUPO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ESPECIE" msprop:Generator_ColumnVarNameInTable="columnESPECIE" msprop:Generator_ColumnPropNameInRow="ESPECIE" msprop:Generator_ColumnPropNameInTable="ESPECIEColumn" msprop:Generator_UserColumnName="ESPECIE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FOTO" msprop:Generator_ColumnVarNameInTable="columnFOTO" msprop:Generator_ColumnPropNameInRow="FOTO" msprop:Generator_ColumnPropNameInTable="FOTOColumn" msprop:Generator_UserColumnName="FOTO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="COMPETICAO" msprop:Generator_TableClassName="COMPETICAODataTable" msprop:Generator_TableVarName="tableCOMPETICAO" msprop:Generator_RowChangedName="COMPETICAORowChanged" msprop:Generator_TablePropName="COMPETICAO" msprop:Generator_RowDeletingName="COMPETICAORowDeleting" msprop:Generator_RowChangingName="COMPETICAORowChanging" msprop:Generator_RowEvHandlerName="COMPETICAORowChangeEventHandler" msprop:Generator_RowDeletedName="COMPETICAORowDeleted" msprop:Generator_RowClassName="COMPETICAORow" msprop:Generator_UserTableName="COMPETICAO" msprop:Generator_RowEvArgName="COMPETICAORowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_COMPETICAO" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnVarNameInTable="columnID_COMPETICAO" msprop:Generator_ColumnPropNameInRow="ID_COMPETICAO" msprop:Generator_ColumnPropNameInTable="ID_COMPETICAOColumn" msprop:Generator_UserColumnName="ID_COMPETICAO" type="xs:int" />
              <xs:element name="NOME" msprop:Generator_ColumnVarNameInTable="columnNOME" msprop:Generator_ColumnPropNameInRow="NOME" msprop:Generator_ColumnPropNameInTable="NOMEColumn" msprop:Generator_UserColumnName="NOME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DATA" msprop:Generator_ColumnVarNameInTable="columnDATA" msprop:Generator_ColumnPropNameInRow="DATA" msprop:Generator_ColumnPropNameInTable="DATAColumn" msprop:Generator_UserColumnName="DATA" type="xs:dateTime" minOccurs="0" />
              <xs:element name="IDPEAO" msprop:Generator_ColumnVarNameInTable="columnIDPEAO" msprop:Generator_ColumnPropNameInRow="IDPEAO" msprop:Generator_ColumnPropNameInTable="IDPEAOColumn" msprop:Generator_UserColumnName="IDPEAO" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="JUIZ" msprop:Generator_TableClassName="JUIZDataTable" msprop:Generator_TableVarName="tableJUIZ" msprop:Generator_RowChangedName="JUIZRowChanged" msprop:Generator_TablePropName="JUIZ" msprop:Generator_RowDeletingName="JUIZRowDeleting" msprop:Generator_RowChangingName="JUIZRowChanging" msprop:Generator_RowEvHandlerName="JUIZRowChangeEventHandler" msprop:Generator_RowDeletedName="JUIZRowDeleted" msprop:Generator_RowClassName="JUIZRow" msprop:Generator_UserTableName="JUIZ" msprop:Generator_RowEvArgName="JUIZRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_JUIZ" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID_JUIZ" msprop:Generator_ColumnPropNameInRow="ID_JUIZ" msprop:Generator_ColumnPropNameInTable="ID_JUIZColumn" msprop:Generator_UserColumnName="ID_JUIZ" type="xs:int" />
              <xs:element name="NOME" msprop:Generator_ColumnVarNameInTable="columnNOME" msprop:Generator_ColumnPropNameInRow="NOME" msprop:Generator_ColumnPropNameInTable="NOMEColumn" msprop:Generator_UserColumnName="NOME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="APELIDO" msprop:Generator_ColumnVarNameInTable="columnAPELIDO" msprop:Generator_ColumnPropNameInRow="APELIDO" msprop:Generator_ColumnPropNameInTable="APELIDOColumn" msprop:Generator_UserColumnName="APELIDO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CIDADE" msprop:Generator_ColumnVarNameInTable="columnCIDADE" msprop:Generator_ColumnPropNameInRow="CIDADE" msprop:Generator_ColumnPropNameInTable="CIDADEColumn" msprop:Generator_UserColumnName="CIDADE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PEAO" msprop:Generator_TableClassName="PEAODataTable" msprop:Generator_TableVarName="tablePEAO" msprop:Generator_RowChangedName="PEAORowChanged" msprop:Generator_TablePropName="PEAO" msprop:Generator_RowDeletingName="PEAORowDeleting" msprop:Generator_RowChangingName="PEAORowChanging" msprop:Generator_RowEvHandlerName="PEAORowChangeEventHandler" msprop:Generator_RowDeletedName="PEAORowDeleted" msprop:Generator_RowClassName="PEAORow" msprop:Generator_UserTableName="PEAO" msprop:Generator_RowEvArgName="PEAORowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_PEAO" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnVarNameInTable="columnID_PEAO" msprop:Generator_ColumnPropNameInRow="ID_PEAO" msprop:Generator_ColumnPropNameInTable="ID_PEAOColumn" msprop:Generator_UserColumnName="ID_PEAO" type="xs:int" />
              <xs:element name="NOME" msprop:Generator_ColumnVarNameInTable="columnNOME" msprop:Generator_ColumnPropNameInRow="NOME" msprop:Generator_ColumnPropNameInTable="NOMEColumn" msprop:Generator_UserColumnName="NOME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CIDADE" msprop:Generator_ColumnVarNameInTable="columnCIDADE" msprop:Generator_ColumnPropNameInRow="CIDADE" msprop:Generator_ColumnPropNameInTable="CIDADEColumn" msprop:Generator_UserColumnName="CIDADE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GRUPO" msprop:Generator_ColumnVarNameInTable="columnGRUPO" msprop:Generator_ColumnPropNameInRow="GRUPO" msprop:Generator_ColumnPropNameInTable="GRUPOColumn" msprop:Generator_UserColumnName="GRUPO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CATEGORIA" msprop:Generator_ColumnVarNameInTable="columnCATEGORIA" msprop:Generator_ColumnPropNameInRow="CATEGORIA" msprop:Generator_ColumnPropNameInTable="CATEGORIAColumn" msprop:Generator_UserColumnName="CATEGORIA" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="APELIDO" msprop:Generator_ColumnVarNameInTable="columnAPELIDO" msprop:Generator_ColumnPropNameInRow="APELIDO" msprop:Generator_ColumnPropNameInTable="APELIDOColumn" msprop:Generator_UserColumnName="APELIDO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FOTO" msprop:Generator_ColumnVarNameInTable="columnFOTO" msprop:Generator_ColumnPropNameInRow="FOTO" msprop:Generator_ColumnPropNameInTable="FOTOColumn" msprop:Generator_UserColumnName="FOTO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ATIVO" msprop:Generator_ColumnVarNameInTable="columnATIVO" msprop:Generator_ColumnPropNameInRow="ATIVO" msprop:Generator_ColumnPropNameInTable="ATIVOColumn" msprop:Generator_UserColumnName="ATIVO" type="xs:boolean" default="true" minOccurs="0" />
              <xs:element name="id_comp" msprop:Generator_ColumnVarNameInTable="columnid_comp" msprop:Generator_ColumnPropNameInRow="id_comp" msprop:Generator_ColumnPropNameInTable="id_compColumn" msprop:Generator_UserColumnName="id_comp" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="RANKING" msprop:Generator_TableClassName="RANKINGDataTable" msprop:Generator_TableVarName="tableRANKING" msprop:Generator_RowChangedName="RANKINGRowChanged" msprop:Generator_TablePropName="RANKING" msprop:Generator_RowDeletingName="RANKINGRowDeleting" msprop:Generator_RowChangingName="RANKINGRowChanging" msprop:Generator_RowEvHandlerName="RANKINGRowChangeEventHandler" msprop:Generator_RowDeletedName="RANKINGRowDeleted" msprop:Generator_RowClassName="RANKINGRow" msprop:Generator_UserTableName="RANKING" msprop:Generator_RowEvArgName="RANKINGRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_RANK" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnVarNameInTable="columnID_RANK" msprop:Generator_ColumnPropNameInRow="ID_RANK" msprop:Generator_ColumnPropNameInTable="ID_RANKColumn" msprop:Generator_UserColumnName="ID_RANK" type="xs:int" />
              <xs:element name="ID_PEAO" msprop:Generator_ColumnVarNameInTable="columnID_PEAO" msprop:Generator_ColumnPropNameInRow="ID_PEAO" msprop:Generator_ColumnPropNameInTable="ID_PEAOColumn" msprop:Generator_UserColumnName="ID_PEAO" type="xs:int" minOccurs="0" />
              <xs:element name="ID_ANIMAL" msprop:Generator_ColumnVarNameInTable="columnID_ANIMAL" msprop:Generator_ColumnPropNameInRow="ID_ANIMAL" msprop:Generator_ColumnPropNameInTable="ID_ANIMALColumn" msprop:Generator_UserColumnName="ID_ANIMAL" type="xs:int" minOccurs="0" />
              <xs:element name="ID_COMP" msprop:Generator_ColumnVarNameInTable="columnID_COMP" msprop:Generator_ColumnPropNameInRow="ID_COMP" msprop:Generator_ColumnPropNameInTable="ID_COMPColumn" msprop:Generator_UserColumnName="ID_COMP" type="xs:int" minOccurs="0" />
              <xs:element name="NOTA1" msprop:Generator_ColumnVarNameInTable="columnNOTA1" msprop:Generator_ColumnPropNameInRow="NOTA1" msprop:Generator_ColumnPropNameInTable="NOTA1Column" msprop:Generator_UserColumnName="NOTA1" type="xs:double" minOccurs="0" />
              <xs:element name="NOTA2" msprop:Generator_ColumnVarNameInTable="columnNOTA2" msprop:Generator_ColumnPropNameInRow="NOTA2" msprop:Generator_ColumnPropNameInTable="NOTA2Column" msprop:Generator_UserColumnName="NOTA2" type="xs:double" minOccurs="0" />
              <xs:element name="MEDIA" msprop:Generator_ColumnVarNameInTable="columnMEDIA" msprop:Generator_ColumnPropNameInRow="MEDIA" msprop:Generator_ColumnPropNameInTable="MEDIAColumn" msprop:Generator_UserColumnName="MEDIA" type="xs:double" minOccurs="0" />
              <xs:element name="TEMPO" msprop:Generator_ColumnVarNameInTable="columnTEMPO" msprop:Generator_ColumnPropNameInRow="TEMPO" msprop:Generator_ColumnPropNameInTable="TEMPOColumn" msprop:Generator_UserColumnName="TEMPO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ANIMAL" />
      <xs:field xpath="mstns:ID_ANIMAL" />
    </xs:unique>
    <xs:unique name="COMPETICAO_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:COMPETICAO" />
      <xs:field xpath="mstns:ID_COMPETICAO" />
    </xs:unique>
    <xs:unique name="JUIZ_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:JUIZ" />
      <xs:field xpath="mstns:ID_JUIZ" />
    </xs:unique>
    <xs:unique name="PEAO_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PEAO" />
      <xs:field xpath="mstns:ID_PEAO" />
    </xs:unique>
    <xs:unique name="RANKING_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:RANKING" />
      <xs:field xpath="mstns:ID_RANK" />
    </xs:unique>
    <xs:unique name="RANKINGKey1">
      <xs:selector xpath=".//mstns:RANKING" />
      <xs:field xpath="mstns:ID_PEAO" />
      <xs:field xpath="mstns:ID_COMP" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="ANIMALRANKING" msdata:parent="ANIMAL" msdata:child="RANKING" msdata:parentkey="ID_ANIMAL" msdata:childkey="ID_ANIMAL" msprop:Generator_UserChildTable="RANKING" msprop:Generator_ChildPropName="GetRANKINGRows" msprop:Generator_UserRelationName="ANIMALRANKING" msprop:Generator_RelationVarName="relationANIMALRANKING" msprop:Generator_UserParentTable="ANIMAL" msprop:Generator_ParentPropName="ANIMALRow" />
      <msdata:Relationship name="COMPETICAORANKING" msdata:parent="COMPETICAO" msdata:child="RANKING" msdata:parentkey="ID_COMPETICAO" msdata:childkey="ID_COMP" msprop:Generator_UserChildTable="RANKING" msprop:Generator_ChildPropName="GetRANKINGRows" msprop:Generator_UserRelationName="COMPETICAORANKING" msprop:Generator_RelationVarName="relationCOMPETICAORANKING" msprop:Generator_UserParentTable="COMPETICAO" msprop:Generator_ParentPropName="COMPETICAORow" />
      <msdata:Relationship name="RANKINGPEAO" msdata:parent="RANKING" msdata:child="PEAO" msdata:parentkey="ID_RANK" msdata:childkey="ID_PEAO" msprop:Generator_UserChildTable="PEAO" msprop:Generator_ChildPropName="GetPEAORows" msprop:Generator_UserRelationName="RANKINGPEAO" msprop:Generator_RelationVarName="relationRANKINGPEAO" msprop:Generator_UserParentTable="RANKING" msprop:Generator_ParentPropName="RANKINGRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>